package ru.compft.common.data.meta;

/**
 * Created by IntelliJ IDEA.
 * User: VVasiliev
 * Date: 20.09.12
 * Time: 8:49
 * Мета данные для таблицы Users (Пользователи)
 */
public interface UserTableMeta {
    //    Таблица
    String TABLE_NAME = "USERS";
    String TABLE_DESCRIPTION = "Пользователи";  // Описание таблицы. Отображаются в кешах

    //    Поля таблицы
    String ID = "ID"; //INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    String LOGIN = "LOGIN"; //VARCHAR(100) NOT NULL UNIQUE,
    String PASSWORD = "PASSWORD"; //VARCHAR(100) NOT NULL,
    String FIRST_NAME = "FIRST_NAME"; //VARCHAR(1000) NULL,
    String LAST_NAME = "LAST_NAME"; //VARCHAR(1000) NULL,
    String ENABLED = "ENABLED"; //VARCHAR(1) NOT NULL,
    String ACCOUNT_NON_EXPIRED = "ACCOUNT_NON_EXPIRED"; //VARCHAR(1) NOT NULL,
    String CREDENTIALS_NON_EXPIRED = "CREDENTIALS_NON_EXPIRED"; //VARCHAR(1) NOT NULL,
    String ACCOUNT_NON_LOCKED = "ACCOUNT_NON_LOCKED"; //VARCHAR(1) NOT NULL,
    String REG_DATE = "REG_DATE"; //DATETIME NOT NULL,
    String LAST_ACTIVITY = "LAST_ACTIVITY"; //DATETIME NOT NULL
}
